Pandas Profiling Report

Dataset statistics

Number of variables	32
Number of observations	97373
Missing cells	495037
Missing cells (%)	15.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	65.3 MiB
Average record size in memory	703.4 B

Variable types

DateTime	1
Categorical	5
Numeric	21
Text	4
Unsupported	1

Alerts

`CANCELLED` has constant value "0.0"	Constant
`AIRLINE` is highly overall correlated with `AIRLINE_CODE` and 2 other fields	High correlation
`AIRLINE_CODE` is highly overall correlated with `AIRLINE` and 2 other fields	High correlation
`AIRLINE_DOT` is highly overall correlated with `AIRLINE` and 2 other fields	High correlation
`AIR_TIME` is highly overall correlated with `CRS_ELAPSED_TIME` and 3 other fields	High correlation
`ARR_DELAY` is highly overall correlated with `DEP_DELAY` and 1 other fields	High correlation
`ARR_TIME` is highly overall correlated with `CRS_ARR_TIME` and 4 other fields	High correlation
`CRS_ARR_TIME` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`CRS_DEP_TIME` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`CRS_ELAPSED_TIME` is highly overall correlated with `AIR_TIME` and 2 other fields	High correlation
`DELAY_DUE_CARRIER` is highly overall correlated with `DIVERTED`	High correlation
`DELAY_DUE_LATE_AIRCRAFT` is highly overall correlated with `DIVERTED`	High correlation
`DELAY_DUE_NAS` is highly overall correlated with `DIVERTED`	High correlation
`DELAY_DUE_SECURITY` is highly overall correlated with `DIVERTED`	High correlation
`DELAY_DUE_WEATHER` is highly overall correlated with `DIVERTED`	High correlation
`DEP_DELAY` is highly overall correlated with `ARR_DELAY`	High correlation
`DEP_TIME` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`DISTANCE` is highly overall correlated with `AIR_TIME` and 2 other fields	High correlation
`DIVERTED` is highly overall correlated with `AIR_TIME` and 7 other fields	High correlation
`DOT_CODE` is highly overall correlated with `AIRLINE` and 2 other fields	High correlation
`ELAPSED_TIME` is highly overall correlated with `AIR_TIME` and 3 other fields	High correlation
`WHEELS_OFF` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`WHEELS_ON` is highly overall correlated with `ARR_TIME` and 4 other fields	High correlation
`DIVERTED` is highly imbalanced (97.6%)	Imbalance
`CANCELLATION_CODE` has 97373 (100.0%) missing values	Missing
`DELAY_DUE_CARRIER` has 79381 (81.5%) missing values	Missing
`DELAY_DUE_WEATHER` has 79381 (81.5%) missing values	Missing
`DELAY_DUE_NAS` has 79381 (81.5%) missing values	Missing
`DELAY_DUE_SECURITY` has 79381 (81.5%) missing values	Missing
`DELAY_DUE_LATE_AIRCRAFT` has 79381 (81.5%) missing values	Missing
`DELAY_DUE_SECURITY` is highly skewed (γ1 = 50.5875775)	Skewed
`CANCELLATION_CODE` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`DEP_DELAY` has 4850 (5.0%) zeros	Zeros
`ARR_DELAY` has 1853 (1.9%) zeros	Zeros
`DELAY_DUE_CARRIER` has 8088 (8.3%) zeros	Zeros
`DELAY_DUE_WEATHER` has 16957 (17.4%) zeros	Zeros
`DELAY_DUE_NAS` has 9248 (9.5%) zeros	Zeros
`DELAY_DUE_SECURITY` has 17890 (18.4%) zeros	Zeros
`DELAY_DUE_LATE_AIRCRAFT` has 9369 (9.6%) zeros	Zeros

Reproduction

Analysis started	2025-07-08 18:59:38.583893
Analysis finished	2025-07-08 19:00:10.232913
Duration	31.65 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

FL_DATE
Date

Distinct	1704
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2019-01-01 00:00:00
Maximum	2023-08-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

AIRLINE
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.1 MiB

Southwest Airlines Co.	18496
Delta Air Lines Inc.	12875
American Airlines Inc.	12508
SkyWest Airlines Inc.	11075
United Air Lines Inc.	8314
Other values (13)	34105

Length

Max length	34
Median length	22
Mean length	19.59916
Min length	9

Characters and Unicode

Total characters	1908429
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Allegiant Air
2nd row	PSA Airlines Inc.
3rd row	Southwest Airlines Co.
4th row	Southwest Airlines Co.
5th row	Delta Air Lines Inc.

Common Values

Value	Count	Frequency (%)
Southwest Airlines Co.	18496	19.0%
Delta Air Lines Inc.	12875	13.2%
American Airlines Inc.	12508	12.8%
SkyWest Airlines Inc.	11075	11.4%
United Air Lines Inc.	8314	8.5%
Republic Airline	4796	4.9%
Envoy Air	3847	4.0%
Endeavor Air Inc.	3669	3.8%
JetBlue Airways	3609	3.7%
PSA Airlines Inc.	3557	3.7%
Other values (8)	14627	15.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	60552	20.2%
airlines	54810	18.3%
air	34158	11.4%
lines	24322	8.1%
southwest	18496	6.2%
co	18496	6.2%
delta	12875	4.3%
american	12508	4.2%
skywest	11075	3.7%
united	8314	2.8%
Other values (18)	44370	14.8%

Most occurring characters

Value	Count	Frequency (%)
i	219621	11.5%
	202603	10.6%
n	178270	9.3%
e	169965	8.9%
r	122254	6.4%
s	118974	6.2%
A	118492	6.2%
l	87605	4.6%
t	80431	4.2%
.	79048	4.1%
Other values (33)	531166	27.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1908429	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	219621	11.5%
	202603	10.6%
n	178270	9.3%
e	169965	8.9%
r	122254	6.4%
s	118974	6.2%
A	118492	6.2%
l	87605	4.6%
t	80431	4.2%
.	79048	4.1%
Other values (33)	531166	27.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1908429	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	219621	11.5%
	202603	10.6%
n	178270	9.3%
e	169965	8.9%
r	122254	6.4%
s	118974	6.2%
A	118492	6.2%
l	87605	4.6%
t	80431	4.2%
.	79048	4.1%
Other values (33)	531166	27.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1908429	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	219621	11.5%
	202603	10.6%
n	178270	9.3%
e	169965	8.9%
r	122254	6.4%
s	118974	6.2%
A	118492	6.2%
l	87605	4.6%
t	80431	4.2%
.	79048	4.1%
Other values (33)	531166	27.8%

AIRLINE_DOT
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

Southwest Airlines Co.: WN	18496
Delta Air Lines Inc.: DL	12875
American Airlines Inc.: AA	12508
SkyWest Airlines Inc.: OO	11075
United Air Lines Inc.: UA	8314
Other values (13)	34105

Length

Max length	38
Median length	26
Mean length	23.59916
Min length	13

Characters and Unicode

Total characters	2297921
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Allegiant Air: G4
2nd row	PSA Airlines Inc.: OH
3rd row	Southwest Airlines Co.: WN
4th row	Southwest Airlines Co.: WN
5th row	Delta Air Lines Inc.: DL

Common Values

Value	Count	Frequency (%)
Southwest Airlines Co.: WN	18496	19.0%
Delta Air Lines Inc.: DL	12875	13.2%
American Airlines Inc.: AA	12508	12.8%
SkyWest Airlines Inc.: OO	11075	11.4%
United Air Lines Inc.: UA	8314	8.5%
Republic Airline: YX	4796	4.9%
Envoy Air: MQ	3847	4.0%
Endeavor Air Inc.: 9E	3669	3.8%
JetBlue Airways: B6	3609	3.7%
PSA Airlines Inc.: OH	3557	3.7%
Other values (8)	14627	15.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	60552	15.2%
airlines	54810	13.8%
air	34158	8.6%
lines	24322	6.1%
southwest	18496	4.7%
co	18496	4.7%
wn	18496	4.7%
delta	12875	3.2%
dl	12875	3.2%
american	12508	3.1%
Other values (36)	129761	32.7%

Most occurring characters

Value	Count	Frequency (%)
	299976	13.1%
i	219621	9.6%
n	178270	7.8%
e	169965	7.4%
A	156195	6.8%
r	122254	5.3%
s	118974	5.2%
:	97373	4.2%
l	87605	3.8%
t	80431	3.5%
Other values (45)	767257	33.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2297921	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	299976	13.1%
i	219621	9.6%
n	178270	7.8%
e	169965	7.4%
A	156195	6.8%
r	122254	5.3%
s	118974	5.2%
:	97373	4.2%
l	87605	3.8%
t	80431	3.5%
Other values (45)	767257	33.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2297921	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	299976	13.1%
i	219621	9.6%
n	178270	7.8%
e	169965	7.4%
A	156195	6.8%
r	122254	5.3%
s	118974	5.2%
:	97373	4.2%
l	87605	3.8%
t	80431	3.5%
Other values (45)	767257	33.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2297921	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	299976	13.1%
i	219621	9.6%
n	178270	7.8%
e	169965	7.4%
A	156195	6.8%
r	122254	5.3%
s	118974	5.2%
:	97373	4.2%
l	87605	3.8%
t	80431	3.5%
Other values (45)	767257	33.4%

AIRLINE_CODE
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.5 MiB

WN	18496
DL	12875
AA	12508
OO	11075
UA	8314
Other values (13)	34105

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	194746
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	G4
2nd row	OH
3rd row	WN
4th row	WN
5th row	DL

Common Values

Value	Count	Frequency (%)
WN	18496	19.0%
DL	12875	13.2%
AA	12508	12.8%
OO	11075	11.4%
UA	8314	8.5%
YX	4796	4.9%
MQ	3847	4.0%
9E	3669	3.8%
B6	3609	3.7%
OH	3557	3.7%
Other values (8)	14627	15.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
wn	18496	19.0%
dl	12875	13.2%
aa	12508	12.8%
oo	11075	11.4%
ua	8314	8.5%
yx	4796	4.9%
mq	3847	4.0%
9e	3669	3.8%
b6	3609	3.7%
oh	3557	3.7%
Other values (8)	14627	15.0%

Most occurring characters

Value	Count	Frequency (%)
A	37703	19.4%
O	25707	13.2%
N	21629	11.1%
W	18496	9.5%
L	12875	6.6%
D	12875	6.6%
U	8314	4.3%
Y	6829	3.5%
9	5817	3.0%
X	5451	2.8%
Other values (12)	39050	20.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	194746	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	37703	19.4%
O	25707	13.2%
N	21629	11.1%
W	18496	9.5%
L	12875	6.6%
D	12875	6.6%
U	8314	4.3%
Y	6829	3.5%
9	5817	3.0%
X	5451	2.8%
Other values (12)	39050	20.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	194746	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	37703	19.4%
O	25707	13.2%
N	21629	11.1%
W	18496	9.5%
L	12875	6.6%
D	12875	6.6%
U	8314	4.3%
Y	6829	3.5%
9	5817	3.0%
X	5451	2.8%
Other values (12)	39050	20.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	194746	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	37703	19.4%
O	25707	13.2%
N	21629	11.1%
W	18496	9.5%
L	12875	6.6%
D	12875	6.6%
U	8314	4.3%
Y	6829	3.5%
9	5817	3.0%
X	5451	2.8%
Other values (12)	39050	20.1%

DOT_CODE
Real number (ℝ)

HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19977.667

Minimum	19393
Maximum	20452
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	19393
5-th percentile	19393
Q1	19790
median	19930
Q3	20368
95-th percentile	20436
Maximum	20452
Range	1059
Interquartile range (IQR)	578

Descriptive statistics

Standard deviation	376.45574
Coefficient of variation (CV)	0.018843829
Kurtosis	-1.3026042
Mean	19977.667
Median Absolute Deviation (MAD)	374
Skewness	-0.23202036
Sum	1.9452853 × 10⁹
Variance	141718.93
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
19393	18496	19.0%
19790	12875	13.2%
19805	12508	12.8%
20304	11075	11.4%
19977	8314	8.5%
20452	4796	4.9%
20398	3847	4.0%
20363	3669	3.8%
20409	3609	3.7%
20397	3557	3.7%
Other values (8)	14627	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19393	18496	19.0%
19687	655	0.7%
19690	984	1.0%
19790	12875	13.2%
19805	12508	12.8%
19930	3389	3.5%
19977	8314	8.5%
20304	11075	11.4%
20363	3669	3.8%
20366	620	0.6%

Value	Count	Frequency (%)
20452	4796	4.9%
20436	2148	2.2%
20416	3133	3.2%
20409	3609	3.7%
20398	3847	4.0%
20397	3557	3.7%
20378	2033	2.1%
20368	1665	1.7%
20366	620	0.6%
20363	3669	3.8%

FL_NUMBER
Real number (ℝ)

Distinct	6537
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2510.9279

Minimum	1
Maximum	8819
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	263
Q1	1055
median	2149
Q3	3791
95-th percentile	5648
Maximum	8819
Range	8818
Interquartile range (IQR)	2736

Descriptive statistics

Standard deviation	1744.4586
Coefficient of variation (CV)	0.69474659
Kurtosis	-0.89400184
Mean	2510.9279
Median Absolute Deviation (MAD)	1332
Skewness	0.50618462
Sum	2.4449659 × 10⁸
Variance	3043135.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
320	53	0.1%
676	52	0.1%
334	51	0.1%
710	47	< 0.1%
350	46	< 0.1%
55	46	< 0.1%
546	45	< 0.1%
61	45	< 0.1%
678	44	< 0.1%
431	44	< 0.1%
Other values (6527)	96900	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	27	< 0.1%
2	24	< 0.1%
3	30	< 0.1%
4	21	< 0.1%
5	27	< 0.1%
6	31	< 0.1%
7	21	< 0.1%
8	25	< 0.1%
9	14	< 0.1%
10	27	< 0.1%

Value	Count	Frequency (%)
8819	1	< 0.1%
8795	1	< 0.1%
8783	1	< 0.1%
8771	1	< 0.1%
7439	1	< 0.1%
7438	1	< 0.1%
7436	1	< 0.1%
7434	2	< 0.1%
7429	2	< 0.1%
7426	1	< 0.1%

ORIGIN
Text

Distinct	372
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	5.6 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	292119
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	PGD
2nd row	EWN
3rd row	ABQ
4th row	PIT
5th row	LAX

Value	Count	Frequency (%)
atl	5006	5.1%
dfw	4310	4.4%
ord	3937	4.0%
den	3775	3.9%
clt	3029	3.1%
lax	2814	2.9%
phx	2415	2.5%
sea	2409	2.5%
las	2341	2.4%
iah	2138	2.2%
Other values (362)	65199	67.0%

Most occurring characters

Value	Count	Frequency (%)
A	32982	11.3%
L	27058	9.3%
S	24502	8.4%
D	23178	7.9%
T	16306	5.6%
C	14955	5.1%
O	14786	5.1%
M	12934	4.4%
F	12241	4.2%
W	11778	4.0%
Other values (16)	101399	34.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	32982	11.3%
L	27058	9.3%
S	24502	8.4%
D	23178	7.9%
T	16306	5.6%
C	14955	5.1%
O	14786	5.1%
M	12934	4.4%
F	12241	4.2%
W	11778	4.0%
Other values (16)	101399	34.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	32982	11.3%
L	27058	9.3%
S	24502	8.4%
D	23178	7.9%
T	16306	5.6%
C	14955	5.1%
O	14786	5.1%
M	12934	4.4%
F	12241	4.2%
W	11778	4.0%
Other values (16)	101399	34.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	32982	11.3%
L	27058	9.3%
S	24502	8.4%
D	23178	7.9%
T	16306	5.6%
C	14955	5.1%
O	14786	5.1%
M	12934	4.4%
F	12241	4.2%
W	11778	4.0%
Other values (16)	101399	34.7%

ORIGIN_CITY
Text

Distinct	366
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	6.5 MiB

Length

Max length	34
Median length	29
Mean length	13.129677
Min length	8

Characters and Unicode

Total characters	1278476
Distinct characters	58
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Punta Gorda, FL
2nd row	New Bern/Morehead/Beaufort, NC
3rd row	Albuquerque, NM
4th row	Pittsburgh, PA
5th row	Los Angeles, CA

Value	Count	Frequency (%)
tx	10694	4.7%
ca	10309	4.5%
fl	8328	3.7%
ga	5364	2.4%
il	5295	2.3%
chicago	5056	2.2%
atlanta	5006	2.2%
san	4921	2.2%
ny	4829	2.1%
new	4469	2.0%
Other values (442)	162431	71.6%

Most occurring characters

Value	Count	Frequency (%)
	129329	10.1%
a	97503	7.6%
,	97373	7.6%
o	71457	5.6%
e	67321	5.3%
t	63640	5.0%
n	62447	4.9%
l	57173	4.5%
i	49094	3.8%
r	46455	3.6%
Other values (48)	536684	42.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1278476	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	129329	10.1%
a	97503	7.6%
,	97373	7.6%
o	71457	5.6%
e	67321	5.3%
t	63640	5.0%
n	62447	4.9%
l	57173	4.5%
i	49094	3.8%
r	46455	3.6%
Other values (48)	536684	42.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1278476	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	129329	10.1%
a	97503	7.6%
,	97373	7.6%
o	71457	5.6%
e	67321	5.3%
t	63640	5.0%
n	62447	4.9%
l	57173	4.5%
i	49094	3.8%
r	46455	3.6%
Other values (48)	536684	42.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1278476	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	129329	10.1%
a	97503	7.6%
,	97373	7.6%
o	71457	5.6%
e	67321	5.3%
t	63640	5.0%
n	62447	4.9%
l	57173	4.5%
i	49094	3.8%
r	46455	3.6%
Other values (48)	536684	42.0%

DEST
Text

Distinct	376
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	5.6 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	292119
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	SPI
2nd row	CLT
3rd row	DEN
4th row	STL
5th row	SEA

Value	Count	Frequency (%)
atl	5025	5.2%
dfw	4117	4.2%
ord	4046	4.2%
den	3832	3.9%
clt	3187	3.3%
lax	2742	2.8%
phx	2566	2.6%
las	2349	2.4%
sea	2279	2.3%
mco	2112	2.2%
Other values (366)	65118	66.9%

Most occurring characters

Value	Count	Frequency (%)
A	32675	11.2%
L	27210	9.3%
S	24426	8.4%
D	23147	7.9%
T	16248	5.6%
C	15051	5.2%
O	15024	5.1%
M	13135	4.5%
F	12061	4.1%
P	11552	4.0%
Other values (16)	101590	34.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	32675	11.2%
L	27210	9.3%
S	24426	8.4%
D	23147	7.9%
T	16248	5.6%
C	15051	5.2%
O	15024	5.1%
M	13135	4.5%
F	12061	4.1%
P	11552	4.0%
Other values (16)	101590	34.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	32675	11.2%
L	27210	9.3%
S	24426	8.4%
D	23147	7.9%
T	16248	5.6%
C	15051	5.2%
O	15024	5.1%
M	13135	4.5%
F	12061	4.1%
P	11552	4.0%
Other values (16)	101590	34.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	32675	11.2%
L	27210	9.3%
S	24426	8.4%
D	23147	7.9%
T	16248	5.6%
C	15051	5.2%
O	15024	5.1%
M	13135	4.5%
F	12061	4.1%
P	11552	4.0%
Other values (16)	101590	34.8%

DEST_CITY
Text

Distinct	369
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	6.5 MiB

Length

Max length	34
Median length	29
Mean length	13.096413
Min length	8

Characters and Unicode

Total characters	1275237
Distinct characters	58
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Springfield, IL
2nd row	Charlotte, NC
3rd row	Denver, CO
4th row	St. Louis, MO
5th row	Seattle, WA

Value	Count	Frequency (%)
tx	10395	4.6%
ca	10270	4.5%
fl	8527	3.8%
il	5411	2.4%
ga	5388	2.4%
chicago	5191	2.3%
atlanta	5025	2.2%
san	4911	2.2%
ny	4648	2.1%
nc	4510	2.0%
Other values (445)	162047	71.6%

Most occurring characters

Value	Count	Frequency (%)
	128950	10.1%
a	97752	7.7%
,	97373	7.6%
o	71066	5.6%
e	67002	5.3%
t	63022	4.9%
n	62379	4.9%
l	56725	4.4%
i	48896	3.8%
r	45912	3.6%
Other values (48)	536160	42.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1275237	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	128950	10.1%
a	97752	7.7%
,	97373	7.6%
o	71066	5.6%
e	67002	5.3%
t	63022	4.9%
n	62379	4.9%
l	56725	4.4%
i	48896	3.8%
r	45912	3.6%
Other values (48)	536160	42.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1275237	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	128950	10.1%
a	97752	7.7%
,	97373	7.6%
o	71066	5.6%
e	67002	5.3%
t	63022	4.9%
n	62379	4.9%
l	56725	4.4%
i	48896	3.8%
r	45912	3.6%
Other values (48)	536160	42.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1275237	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	128950	10.1%
a	97752	7.7%
,	97373	7.6%
o	71066	5.6%
e	67002	5.3%
t	63022	4.9%
n	62379	4.9%
l	56725	4.4%
i	48896	3.8%
r	45912	3.6%
Other values (48)	536160	42.0%

CRS_DEP_TIME
Real number (ℝ)

HIGH CORRELATION

Distinct	1235
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1328.0314

Minimum	4
Maximum	2359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	4
5-th percentile	605
Q1	915
median	1320
Q3	1730
95-th percentile	2120
Maximum	2359
Range	2355
Interquartile range (IQR)	815

Descriptive statistics

Standard deviation	485.08206
Coefficient of variation (CV)	0.365264
Kurtosis	-1.0313097
Mean	1328.0314
Median Absolute Deviation (MAD)	407
Skewness	0.088856519
Sum	1.293144 × 10⁸
Variance	235304.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
600	2004	2.1%
700	1647	1.7%
800	998	1.0%
830	691	0.7%
900	664	0.7%
630	641	0.7%
730	631	0.6%
1000	627	0.6%
1100	559	0.6%
615	516	0.5%
Other values (1225)	88395	90.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	1	< 0.1%
5	2	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	2	< 0.1%
14	3	< 0.1%
15	9	< 0.1%
16	1	< 0.1%
18	2	< 0.1%

Value	Count	Frequency (%)
2359	112	0.1%
2358	10	< 0.1%
2357	3	< 0.1%
2356	8	< 0.1%
2355	52	0.1%
2354	1	< 0.1%
2353	2	< 0.1%
2352	3	< 0.1%
2351	3	< 0.1%
2350	28	< 0.1%

DEP_TIME
Real number (ℝ)

HIGH CORRELATION

Distinct	1332
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1330.8337

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	603
Q1	918
median	1325
Q3	1738
95-th percentile	2133
Maximum	2400
Range	2399
Interquartile range (IQR)	820

Descriptive statistics

Standard deviation	498.81487
Coefficient of variation (CV)	0.37481381
Kurtosis	-0.9639315
Mean	1330.8337
Median Absolute Deviation (MAD)	411
Skewness	0.040479117
Sum	1.2958727 × 10⁸
Variance	248816.27
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
555	279	0.3%
556	253	0.3%
655	227	0.2%
557	222	0.2%
558	220	0.2%
559	214	0.2%
554	214	0.2%
600	202	0.2%
656	198	0.2%
700	188	0.2%
Other values (1322)	95156	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13	< 0.1%
2	8	< 0.1%
3	9	< 0.1%
4	14	< 0.1%
5	8	< 0.1%
6	11	< 0.1%
7	9	< 0.1%
8	11	< 0.1%
9	6	< 0.1%
10	10	< 0.1%

Value	Count	Frequency (%)
2400	8	< 0.1%
2359	9	< 0.1%
2358	16	< 0.1%
2357	20	< 0.1%
2356	14	< 0.1%
2355	18	< 0.1%
2354	9	< 0.1%
2353	19	< 0.1%
2352	14	< 0.1%
2351	20	< 0.1%

DEP_DELAY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	588
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.138262

Minimum	-81
Maximum	1512
Zeros	4850
Zeros (%)	5.0%
Negative	59436
Negative (%)	61.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	-81
5-th percentile	-10
Q1	-6
median	-2
Q3	6
95-th percentile	71
Maximum	1512
Range	1593
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	49.298681
Coefficient of variation (CV)	4.8626363
Kurtosis	190.44197
Mean	10.138262
Median Absolute Deviation (MAD)	4
Skewness	10.815252
Sum	987193
Variance	2430.36
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5	8089	8.3%
-4	7515	7.7%
-3	7076	7.3%
-6	6339	6.5%
-2	6270	6.4%
-1	5498	5.6%
-7	5044	5.2%
0	4850	5.0%
-8	3978	4.1%
-9	2883	3.0%
Other values (578)	39831	40.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-81	1	< 0.1%
-42	2	< 0.1%
-38	1	< 0.1%
-36	1	< 0.1%
-35	2	< 0.1%
-34	2	< 0.1%
-32	1	< 0.1%
-29	5	< 0.1%
-28	1	< 0.1%
-27	8	< 0.1%

Value	Count	Frequency (%)
1512	1	< 0.1%
1469	1	< 0.1%
1441	1	< 0.1%
1376	1	< 0.1%
1286	1	< 0.1%
1256	1	< 0.1%
1255	1	< 0.1%
1214	1	< 0.1%
1211	1	< 0.1%
1205	1	< 0.1%

TAXI_OUT
Real number (ℝ)

Distinct	135
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.680045

Minimum	1
Maximum	163
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	11
median	14
Q3	19
95-th percentile	33
Maximum	163
Range	162
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	9.1710014
Coefficient of variation (CV)	0.54981875
Kurtosis	23.059615
Mean	16.680045
Median Absolute Deviation (MAD)	4
Skewness	3.4143561
Sum	1624186
Variance	84.107267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	8093	8.3%
13	7825	8.0%
11	7818	8.0%
14	7156	7.3%
10	7067	7.3%
15	6460	6.6%
16	5450	5.6%
9	5378	5.5%
17	4749	4.9%
18	4013	4.1%
Other values (125)	33364	34.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	< 0.1%
2	3	< 0.1%
3	20	< 0.1%
4	83	0.1%
5	238	0.2%
6	780	0.8%
7	1803	1.9%
8	3500	3.6%
9	5378	5.5%
10	7067	7.3%

Value	Count	Frequency (%)
163	1	< 0.1%
162	1	< 0.1%
158	1	< 0.1%
157	2	< 0.1%
151	1	< 0.1%
150	1	< 0.1%
147	1	< 0.1%
143	2	< 0.1%
142	2	< 0.1%
139	1	< 0.1%

WHEELS_OFF
Real number (ℝ)

HIGH CORRELATION

Distinct	1338
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1353.6206

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	618
Q1	932
median	1338
Q3	1752
95-th percentile	2146
Maximum	2400
Range	2399
Interquartile range (IQR)	820

Descriptive statistics

Standard deviation	500.4479
Coefficient of variation (CV)	0.36971061
Kurtosis	-0.89992525
Mean	1353.6206
Median Absolute Deviation (MAD)	410
Skewness	0.0066597414
Sum	1.318061 × 10⁸
Variance	250448.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
611	189	0.2%
610	164	0.2%
608	163	0.2%
615	160	0.2%
712	149	0.2%
715	148	0.2%
711	148	0.2%
619	147	0.2%
607	146	0.1%
613	146	0.1%
Other values (1328)	95813	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	22	< 0.1%
2	19	< 0.1%
3	14	< 0.1%
4	12	< 0.1%
5	20	< 0.1%
6	11	< 0.1%
7	14	< 0.1%
8	18	< 0.1%
9	14	< 0.1%
10	23	< 0.1%

Value	Count	Frequency (%)
2400	9	< 0.1%
2359	23	< 0.1%
2358	17	< 0.1%
2357	12	< 0.1%
2356	24	< 0.1%
2355	14	< 0.1%
2354	18	< 0.1%
2353	12	< 0.1%
2352	20	< 0.1%
2351	18	< 0.1%

WHEELS_ON
Real number (ℝ)

HIGH CORRELATION

Distinct	1421
Distinct (%)	1.5%
Missing	28
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1463.905

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	654
Q1	1050
median	1502
Q3	1909
95-th percentile	2247
Maximum	2400
Range	2399
Interquartile range (IQR)	859

Descriptive statistics

Standard deviation	527.43063
Coefficient of variation (CV)	0.36029019
Kurtosis	-0.43288968
Mean	1463.905
Median Absolute Deviation (MAD)	416
Skewness	-0.31773495
Sum	1.4250384 × 10⁸
Variance	278183.07
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1820	136	0.1%
930	132	0.1%
1651	131	0.1%
1802	124	0.1%
1654	123	0.1%
1836	123	0.1%
1641	121	0.1%
1715	121	0.1%
2113	120	0.1%
1627	120	0.1%
Other values (1411)	96094	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	48	< 0.1%
2	49	0.1%
3	44	< 0.1%
4	47	< 0.1%
5	49	0.1%
6	36	< 0.1%
7	45	< 0.1%
8	36	< 0.1%
9	31	< 0.1%
10	40	< 0.1%

Value	Count	Frequency (%)
2400	45	< 0.1%
2359	45	< 0.1%
2358	55	0.1%
2357	62	0.1%
2356	48	< 0.1%
2355	52	0.1%
2354	60	0.1%
2353	63	0.1%
2352	42	< 0.1%
2351	39	< 0.1%

TAXI_IN
Real number (ℝ)

Distinct	120
Distinct (%)	0.1%
Missing	28
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	7.6952899

Minimum	1
Maximum	261
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	4
median	6
Q3	9
95-th percentile	18
Maximum	261
Range	260
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	6.4810638
Coefficient of variation (CV)	0.84221178
Kurtosis	92.748798
Mean	7.6952899
Median Absolute Deviation (MAD)	2
Skewness	6.088001
Sum	749098
Variance	42.004188
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	15144	15.6%
5	14174	14.6%
6	11318	11.6%
3	10444	10.7%
7	9078	9.3%
8	6843	7.0%
9	5283	5.4%
10	4148	4.3%
11	3304	3.4%
2	3062	3.1%
Other values (110)	14547	14.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	183	0.2%
2	3062	3.1%
3	10444	10.7%
4	15144	15.6%
5	14174	14.6%
6	11318	11.6%
7	9078	9.3%
8	6843	7.0%
9	5283	5.4%
10	4148	4.3%

Value	Count	Frequency (%)
261	1	< 0.1%
187	1	< 0.1%
184	1	< 0.1%
177	1	< 0.1%
173	1	< 0.1%
160	1	< 0.1%
155	1	< 0.1%
153	1	< 0.1%
151	1	< 0.1%
145	1	< 0.1%

CRS_ARR_TIME
Real number (ℝ)

HIGH CORRELATION

Distinct	1327
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1490.4567

Minimum	1
Maximum	2359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	725
Q1	1108
median	1517
Q3	1917
95-th percentile	2254
Maximum	2359
Range	2358
Interquartile range (IQR)	809

Descriptive statistics

Standard deviation	512.11088
Coefficient of variation (CV)	0.34359325
Kurtosis	-0.4525262
Mean	1490.4567
Median Absolute Deviation (MAD)	405
Skewness	-0.28411138
Sum	1.4513024 × 10⁸
Variance	262257.55
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2359	317	0.3%
950	288	0.3%
1900	279	0.3%
1000	270	0.3%
2000	258	0.3%
1835	258	0.3%
1400	257	0.3%
1555	256	0.3%
2100	255	0.3%
1800	251	0.3%
Other values (1317)	94684	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	23	< 0.1%
2	27	< 0.1%
3	30	< 0.1%
4	20	< 0.1%
5	80	0.1%
6	27	< 0.1%
7	16	< 0.1%
8	23	< 0.1%
9	19	< 0.1%
10	84	0.1%

Value	Count	Frequency (%)
2359	317	0.3%
2358	101	0.1%
2357	94	0.1%
2356	72	0.1%
2355	163	0.2%
2354	67	0.1%
2353	65	0.1%
2352	69	0.1%
2351	50	0.1%
2350	139	0.1%

ARR_TIME
Real number (ℝ)

HIGH CORRELATION

Distinct	1410
Distinct (%)	1.4%
Missing	28
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1467.1255

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	652
Q1	1053
median	1506
Q3	1913
95-th percentile	2249
Maximum	2400
Range	2399
Interquartile range (IQR)	860

Descriptive statistics

Standard deviation	532.51335
Coefficient of variation (CV)	0.36296373
Kurtosis	-0.35065461
Mean	1467.1255
Median Absolute Deviation (MAD)	413
Skewness	-0.36097268
Sum	1.4281733 × 10⁸
Variance	283570.47
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1115	130	0.1%
1343	129	0.1%
1655	123	0.1%
1020	123	0.1%
1052	122	0.1%
1840	122	0.1%
1230	122	0.1%
1547	121	0.1%
1550	121	0.1%
944	121	0.1%
Other values (1400)	96111	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	67	0.1%
2	50	0.1%
3	61	0.1%
4	42	< 0.1%
5	62	0.1%
6	40	< 0.1%
7	54	0.1%
8	39	< 0.1%
9	48	< 0.1%
10	60	0.1%

Value	Count	Frequency (%)
2400	48	< 0.1%
2359	43	< 0.1%
2358	71	0.1%
2357	59	0.1%
2356	56	0.1%
2355	53	0.1%
2354	59	0.1%
2353	62	0.1%
2352	63	0.1%
2351	68	0.1%

ARR_DELAY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	613
Distinct (%)	0.6%
Missing	225
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	4.3537592

Minimum	-88
Maximum	1520
Zeros	1853
Zeros (%)	1.9%
Negative	62508
Negative (%)	64.2%
Memory size	1.5 MiB

Quantile statistics

Minimum	-88
5-th percentile	-27
Q1	-15
median	-7
Q3	7
95-th percentile	70
Maximum	1520
Range	1608
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	51.360244
Coefficient of variation (CV)	11.796758
Kurtosis	163.6387
Mean	4.3537592
Median Absolute Deviation (MAD)	10
Skewness	9.7045591
Sum	422959
Variance	2637.8747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-11	2861	2.9%
-12	2845	2.9%
-13	2834	2.9%
-9	2825	2.9%
-10	2787	2.9%
-7	2753	2.8%
-14	2747	2.8%
-8	2690	2.8%
-15	2631	2.7%
-16	2534	2.6%
Other values (603)	69641	71.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-88	1	< 0.1%
-68	1	< 0.1%
-67	1	< 0.1%
-66	2	< 0.1%
-63	1	< 0.1%
-62	2	< 0.1%
-61	4	< 0.1%
-60	3	< 0.1%
-59	9	< 0.1%
-58	1	< 0.1%

Value	Count	Frequency (%)
1520	1	< 0.1%
1473	1	< 0.1%
1458	1	< 0.1%
1371	1	< 0.1%
1285	1	< 0.1%
1270	1	< 0.1%
1247	1	< 0.1%
1207	1	< 0.1%
1200	1	< 0.1%
1199	1	< 0.1%

CANCELLED
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.6 MiB

0.0	97373

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	292119
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	97373	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	97373	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	194746	66.7%
.	97373	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	194746	66.7%
.	97373	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	194746	66.7%
.	97373	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	194746	66.7%
.	97373	33.3%

CANCELLATION_CODE
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	97373
Missing (%)	100.0%
Memory size	1.5 MiB

DIVERTED
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.6 MiB

0.0	97148
1.0	225

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	292119
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	97148	99.8%
1.0	225	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	97148	99.8%
1.0	225	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	194521	66.6%
.	97373	33.3%
1	225	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	194521	66.6%
.	97373	33.3%
1	225	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	194521	66.6%
.	97373	33.3%
1	225	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	292119	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	194521	66.6%
.	97373	33.3%
1	225	0.1%

CRS_ELAPSED_TIME
Real number (ℝ)

HIGH CORRELATION

Distinct	501
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	142.8576

Minimum	20
Maximum	695
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	20
5-th percentile	64
Q1	90
median	125
Q3	173
95-th percentile	301
Maximum	695
Range	675
Interquartile range (IQR)	83

Descriptive statistics

Standard deviation	71.980176
Coefficient of variation (CV)	0.50385962
Kurtosis	2.5880795
Mean	142.8576
Median Absolute Deviation (MAD)	40
Skewness	1.444716
Sum	13910473
Variance	5181.1458
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	1864	1.9%
85	1766	1.8%
80	1679	1.7%
70	1516	1.6%
75	1453	1.5%
95	1420	1.5%
115	1235	1.3%
105	1230	1.3%
120	1202	1.2%
110	1195	1.2%
Other values (491)	82813	85.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	3	< 0.1%
21	2	< 0.1%
23	1	< 0.1%
24	1	< 0.1%
25	3	< 0.1%
26	3	< 0.1%
29	1	< 0.1%
30	2	< 0.1%
32	4	< 0.1%
33	3	< 0.1%

Value	Count	Frequency (%)
695	1	< 0.1%
684	1	< 0.1%
680	1	< 0.1%
675	2	< 0.1%
670	2	< 0.1%
665	1	< 0.1%
660	2	< 0.1%
652	1	< 0.1%
650	2	< 0.1%
646	1	< 0.1%

ELAPSED_TIME
Real number (ℝ)

HIGH CORRELATION

Distinct	514
Distinct (%)	0.5%
Missing	225
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	137.07864

Minimum	17
Maximum	706
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	17
5-th percentile	56
Q1	85
median	120
Q3	168
95-th percentile	293
Maximum	706
Range	689
Interquartile range (IQR)	83

Descriptive statistics

Standard deviation	72.041746
Coefficient of variation (CV)	0.52555048
Kurtosis	2.5343943
Mean	137.07864
Median Absolute Deviation (MAD)	40
Skewness	1.4217463
Sum	13316916
Variance	5190.0132
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
87	798	0.8%
79	780	0.8%
85	778	0.8%
83	773	0.8%
76	764	0.8%
82	760	0.8%
81	757	0.8%
75	755	0.8%
72	750	0.8%
77	747	0.8%
Other values (504)	89486	91.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
21	1	< 0.1%
22	2	< 0.1%
23	1	< 0.1%
24	2	< 0.1%
25	5	< 0.1%
26	3	< 0.1%
28	9	< 0.1%

Value	Count	Frequency (%)
706	1	< 0.1%
696	1	< 0.1%
687	1	< 0.1%
682	1	< 0.1%
676	1	< 0.1%
668	1	< 0.1%
657	1	< 0.1%
648	1	< 0.1%
644	1	< 0.1%
641	1	< 0.1%

AIR_TIME
Real number (ℝ)

HIGH CORRELATION

Distinct	492
Distinct (%)	0.5%
Missing	225
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	112.71605

Minimum	9
Maximum	669
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	9
5-th percentile	35
Q1	62
median	95
Q3	142
95-th percentile	267
Maximum	669
Range	660
Interquartile range (IQR)	80

Descriptive statistics

Standard deviation	70.10449
Coefficient of variation (CV)	0.62195658
Kurtosis	2.6192588
Mean	112.71605
Median Absolute Deviation (MAD)	38
Skewness	1.4556215
Sum	10950139
Variance	4914.6396
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
61	860	0.9%
43	858	0.9%
63	851	0.9%
65	835	0.9%
60	832	0.9%
58	828	0.9%
55	827	0.8%
59	824	0.8%
53	818	0.8%
66	811	0.8%
Other values (482)	88804	91.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9	4	< 0.1%
10	4	< 0.1%
11	2	< 0.1%
12	2	< 0.1%
13	4	< 0.1%
14	3	< 0.1%
15	6	< 0.1%
16	15	< 0.1%
17	29	< 0.1%
18	49	0.1%

Value	Count	Frequency (%)
669	1	< 0.1%
659	1	< 0.1%
657	1	< 0.1%
654	2	< 0.1%
634	1	< 0.1%
623	1	< 0.1%
621	1	< 0.1%
614	1	< 0.1%
611	1	< 0.1%
606	1	< 0.1%

DISTANCE
Real number (ℝ)

HIGH CORRELATION

Distinct	1607
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	814.12611

Minimum	29
Maximum	5812
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	29
5-th percentile	175
Q1	387
median	657
Q3	1050
95-th percentile	2158
Maximum	5812
Range	5783
Interquartile range (IQR)	663

Descriptive statistics

Standard deviation	591.63469
Coefficient of variation (CV)	0.72671136
Kurtosis	2.8922065
Mean	814.12611
Median Absolute Deviation (MAD)	320
Skewness	1.5081882
Sum	79273902
Variance	350031.61
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
337	618	0.6%
399	485	0.5%
296	481	0.5%
594	409	0.4%
224	398	0.4%
404	391	0.4%
214	384	0.4%
862	353	0.4%
733	352	0.4%
588	347	0.4%
Other values (1597)	93155	95.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
29	1	< 0.1%
30	1	< 0.1%
31	12	< 0.1%
41	2	< 0.1%
45	10	< 0.1%
50	3	< 0.1%
54	2	< 0.1%
61	4	< 0.1%
66	6	< 0.1%
67	56	0.1%

Value	Count	Frequency (%)
5812	1	< 0.1%
5095	5	< 0.1%
4983	13	< 0.1%
4962	3	< 0.1%
4904	2	< 0.1%
4817	4	< 0.1%
4757	1	< 0.1%
4678	2	< 0.1%
4502	12	< 0.1%
4475	1	< 0.1%

DELAY_DUE_CARRIER
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	422
Distinct (%)	2.3%
Missing	79381
Missing (%)	81.5%
Infinite	0
Infinite (%)	0.0%
Mean	24.91285

Minimum	0
Maximum	1473
Zeros	8088
Zeros (%)	8.3%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	23
95-th percentile	105
Maximum	1473
Range	1473
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	71.923245
Coefficient of variation (CV)	2.8869938
Kurtosis	104.50496
Mean	24.91285
Median Absolute Deviation (MAD)	4
Skewness	8.6833266
Sum	448232
Variance	5172.9531
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8088	8.3%
2	312	0.3%
6	300	0.3%
3	297	0.3%
15	293	0.3%
5	285	0.3%
1	284	0.3%
16	276	0.3%
4	257	0.3%
9	256	0.3%
Other values (412)	7344	7.5%
(Missing)	79381	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8088	8.3%
1	284	0.3%
2	312	0.3%
3	297	0.3%
4	257	0.3%
5	285	0.3%
6	300	0.3%
7	249	0.3%
8	240	0.2%
9	256	0.3%

Value	Count	Frequency (%)
1473	1	< 0.1%
1458	1	< 0.1%
1376	1	< 0.1%
1256	1	< 0.1%
1155	1	< 0.1%
1147	1	< 0.1%
1121	1	< 0.1%
1115	1	< 0.1%
1088	1	< 0.1%
1066	1	< 0.1%

DELAY_DUE_WEATHER
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	224
Distinct (%)	1.2%
Missing	79381
Missing (%)	81.5%
Infinite	0
Infinite (%)	0.0%
Mean	3.8727768

Minimum	0
Maximum	1285
Zeros	16957
Zeros (%)	17.4%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	7
Maximum	1285
Range	1285
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	30.007417
Coefficient of variation (CV)	7.7482951
Kurtosis	538.35721
Mean	3.8727768
Median Absolute Deviation (MAD)	0
Skewness	18.894339
Sum	69679
Variance	900.4451
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16957	17.4%
2	24	< 0.1%
7	22	< 0.1%
16	22	< 0.1%
6	21	< 0.1%
8	20	< 0.1%
9	19	< 0.1%
3	19	< 0.1%
32	19	< 0.1%
18	18	< 0.1%
Other values (214)	851	0.9%
(Missing)	79381	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16957	17.4%
1	17	< 0.1%
2	24	< 0.1%
3	19	< 0.1%
4	16	< 0.1%
5	17	< 0.1%
6	21	< 0.1%
7	22	< 0.1%
8	20	< 0.1%
9	19	< 0.1%

Value	Count	Frequency (%)
1285	1	< 0.1%
1059	1	< 0.1%
1000	1	< 0.1%
989	1	< 0.1%
825	1	< 0.1%
780	1	< 0.1%
733	1	< 0.1%
586	1	< 0.1%
565	1	< 0.1%
554	1	< 0.1%

DELAY_DUE_NAS
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	252
Distinct (%)	1.4%
Missing	79381
Missing (%)	81.5%
Infinite	0
Infinite (%)	0.0%
Mean	13.325311

Minimum	0
Maximum	1207
Zeros	9248
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	17
95-th percentile	56
Maximum	1207
Range	1207
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	33.717869
Coefficient of variation (CV)	2.5303626
Kurtosis	260.9311
Mean	13.325311
Median Absolute Deviation (MAD)	0
Skewness	11.443701
Sum	239749
Variance	1136.8947
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9248	9.5%
1	449	0.5%
15	345	0.4%
3	319	0.3%
17	311	0.3%
16	305	0.3%
2	303	0.3%
5	287	0.3%
6	287	0.3%
18	279	0.3%
Other values (242)	5859	6.0%
(Missing)	79381	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9248	9.5%
1	449	0.5%
2	303	0.3%
3	319	0.3%
4	278	0.3%
5	287	0.3%
6	287	0.3%
7	260	0.3%
8	236	0.2%
9	203	0.2%

Value	Count	Frequency (%)
1207	1	< 0.1%
998	1	< 0.1%
978	1	< 0.1%
880	1	< 0.1%
865	1	< 0.1%
818	1	< 0.1%
696	1	< 0.1%
539	1	< 0.1%
442	1	< 0.1%
439	1	< 0.1%

DELAY_DUE_SECURITY
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	45
Distinct (%)	0.3%
Missing	79381
Missing (%)	81.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.13939529

Minimum	0
Maximum	249
Zeros	17890
Zeros (%)	18.4%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	249
Range	249
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.3412146
Coefficient of variation (CV)	23.969351
Kurtosis	3260.5075
Mean	0.13939529
Median Absolute Deviation (MAD)	0
Skewness	50.587577
Sum	2508
Variance	11.163715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
0	17890	18.4%
10	7	< 0.1%
1	7	< 0.1%
17	6	< 0.1%
14	5	< 0.1%
11	5	< 0.1%
15	5	< 0.1%
7	4	< 0.1%
5	4	< 0.1%
20	4	< 0.1%
Other values (35)	55	0.1%
(Missing)	79381	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17890	18.4%
1	7	< 0.1%
2	2	< 0.1%
3	3	< 0.1%
4	2	< 0.1%
5	4	< 0.1%
6	3	< 0.1%
7	4	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
249	1	< 0.1%
233	1	< 0.1%
117	1	< 0.1%
116	1	< 0.1%
91	1	< 0.1%
81	1	< 0.1%
59	1	< 0.1%
58	1	< 0.1%
54	1	< 0.1%
50	1	< 0.1%

DELAY_DUE_LATE_AIRCRAFT
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	352
Distinct (%)	2.0%
Missing	79381
Missing (%)	81.5%
Infinite	0
Infinite (%)	0.0%
Mean	24.84143

Minimum	0
Maximum	1018
Zeros	9369
Zeros (%)	9.6%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	29
95-th percentile	115
Maximum	1018
Range	1018
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	53.336648
Coefficient of variation (CV)	2.1470845
Kurtosis	70.032194
Mean	24.84143
Median Absolute Deviation (MAD)	0
Skewness	6.1484477
Sum	446947
Variance	2844.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9369	9.6%
15	230	0.2%
16	200	0.2%
17	185	0.2%
18	184	0.2%
19	170	0.2%
12	166	0.2%
24	161	0.2%
20	156	0.2%
13	154	0.2%
Other values (342)	7017	7.2%
(Missing)	79381	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9369	9.6%
1	129	0.1%
2	121	0.1%
3	126	0.1%
4	117	0.1%
5	132	0.1%
6	109	0.1%
7	134	0.1%
8	116	0.1%
9	127	0.1%

Value	Count	Frequency (%)
1018	1	< 0.1%
1013	1	< 0.1%
1012	1	< 0.1%
960	1	< 0.1%
942	1	< 0.1%
889	1	< 0.1%
888	1	< 0.1%
840	1	< 0.1%
820	1	< 0.1%
802	1	< 0.1%

Auto

Heatmap
Table

	AIRLINE	AIRLINE_CODE	AIRLINE_DOT	AIR_TIME	ARR_DELAY	ARR_TIME	CRS_ARR_TIME	CRS_DEP_TIME	CRS_ELAPSED_TIME	DELAY_DUE_CARRIER	DELAY_DUE_LATE_AIRCRAFT	DELAY_DUE_NAS	DELAY_DUE_SECURITY	DELAY_DUE_WEATHER	DEP_DELAY	DEP_TIME	DISTANCE	DIVERTED	DOT_CODE	ELAPSED_TIME	FL_NUMBER	TAXI_IN	TAXI_OUT	WHEELS_OFF	WHEELS_ON
AIRLINE	1.000	1.000	1.000	0.169	0.026	0.048	0.050	0.048	0.174	0.031	0.027	0.052	0.005	0.029	0.026	0.047	0.177	0.011	1.000	0.169	0.415	0.020	0.091	0.049	0.048
AIRLINE_CODE	1.000	1.000	1.000	0.169	0.026	0.048	0.050	0.048	0.174	0.031	0.027	0.052	0.005	0.029	0.026	0.047	0.177	0.011	1.000	0.169	0.415	0.020	0.091	0.049	0.048
AIRLINE_DOT	1.000	1.000	1.000	0.169	0.026	0.048	0.050	0.048	0.174	0.031	0.027	0.052	0.005	0.029	0.026	0.047	0.177	0.011	1.000	0.169	0.415	0.020	0.091	0.049	0.048
AIR_TIME	0.169	0.169	0.169	1.000	0.034	0.044	0.052	-0.027	0.984	0.013	-0.087	0.176	0.016	-0.022	0.075	-0.028	0.986	1.000	-0.064	0.979	-0.334	0.125	0.071	-0.034	0.046
ARR_DELAY	0.026	0.026	0.026	0.034	1.000	0.110	0.112	0.130	-0.027	0.210	0.339	0.004	-0.011	0.136	0.655	0.166	0.004	1.000	-0.033	0.099	-0.039	0.119	0.269	0.171	0.117
ARR_TIME	0.048	0.048	0.048	0.044	0.110	1.000	0.896	0.730	0.039	-0.065	0.128	-0.017	-0.015	0.005	0.132	0.753	0.049	0.036	-0.001	0.044	0.001	-0.028	0.028	0.768	0.976
CRS_ARR_TIME	0.050	0.050	0.050	0.052	0.112	0.896	1.000	0.794	0.049	-0.048	0.210	-0.052	-0.013	0.004	0.144	0.792	0.060	0.017	0.001	0.049	-0.007	-0.037	0.025	0.800	0.904
CRS_DEP_TIME	0.048	0.048	0.048	-0.027	0.130	0.730	0.794	1.000	-0.033	-0.024	0.250	-0.109	-0.009	-0.001	0.160	0.969	-0.022	0.012	0.009	-0.031	0.000	-0.066	0.004	0.953	0.751
CRS_ELAPSED_TIME	0.174	0.174	0.174	0.984	-0.027	0.039	0.049	-0.033	1.000	0.030	-0.066	0.120	0.015	-0.017	0.071	-0.034	0.979	0.012	-0.023	0.974	-0.311	0.163	0.112	-0.038	0.040
DELAY_DUE_CARRIER	0.031	0.031	0.031	0.013	0.210	-0.065	-0.048	-0.024	0.030	1.000	-0.251	-0.368	-0.058	-0.226	0.303	-0.020	0.039	1.000	-0.062	-0.042	-0.024	-0.122	-0.139	-0.026	-0.066
DELAY_DUE_LATE_AIRCRAFT	0.027	0.027	0.027	-0.087	0.339	0.128	0.210	0.250	-0.066	-0.251	1.000	-0.297	-0.013	-0.043	0.452	0.278	-0.056	1.000	-0.056	-0.151	-0.017	-0.079	-0.198	0.259	0.139
DELAY_DUE_NAS	0.052	0.052	0.052	0.176	0.004	-0.017	-0.052	-0.109	0.120	-0.368	-0.297	1.000	-0.013	-0.013	-0.377	-0.125	0.106	1.000	0.128	0.330	-0.056	0.296	0.444	-0.100	-0.019
DELAY_DUE_SECURITY	0.005	0.005	0.005	0.016	-0.011	-0.015	-0.013	-0.009	0.015	-0.058	-0.013	-0.013	1.000	-0.012	0.001	-0.010	0.020	1.000	0.017	0.010	-0.029	-0.012	-0.003	-0.011	-0.014
DELAY_DUE_WEATHER	0.029	0.029	0.029	-0.022	0.136	0.005	0.004	-0.001	-0.017	-0.226	-0.043	-0.013	-0.012	1.000	0.121	0.011	-0.023	1.000	0.048	-0.006	0.040	-0.007	0.063	0.015	0.012
DEP_DELAY	0.026	0.026	0.026	0.075	0.655	0.132	0.144	0.160	0.071	0.303	0.452	-0.377	0.001	0.121	1.000	0.203	0.085	0.018	-0.174	0.074	-0.084	-0.051	0.020	0.199	0.141
DEP_TIME	0.047	0.047	0.047	-0.028	0.166	0.753	0.792	0.969	-0.034	-0.020	0.278	-0.125	-0.010	0.011	0.203	1.000	-0.024	0.013	0.003	-0.030	0.004	-0.064	0.008	0.984	0.774
DISTANCE	0.177	0.177	0.177	0.986	0.004	0.049	0.060	-0.022	0.979	0.039	-0.056	0.106	0.020	-0.023	0.085	-0.024	1.000	0.009	-0.087	0.961	-0.353	0.110	0.055	-0.030	0.052
DIVERTED	0.011	0.011	0.011	1.000	1.000	0.036	0.017	0.012	0.012	1.000	1.000	1.000	1.000	1.000	0.018	0.013	0.009	1.000	0.013	1.000	0.008	0.053	0.014	0.013	0.039
DOT_CODE	1.000	1.000	1.000	-0.064	-0.033	-0.001	0.001	0.009	-0.023	-0.062	-0.056	0.128	0.017	0.048	-0.174	0.003	-0.087	0.013	1.000	-0.006	0.334	0.213	0.279	0.008	-0.003
ELAPSED_TIME	0.169	0.169	0.169	0.979	0.099	0.044	0.049	-0.031	0.974	-0.042	-0.151	0.330	0.010	-0.006	0.074	-0.030	0.961	1.000	-0.006	1.000	-0.305	0.209	0.203	-0.032	0.046
FL_NUMBER	0.415	0.415	0.415	-0.334	-0.039	0.001	-0.007	0.000	-0.311	-0.024	-0.017	-0.056	-0.029	0.040	-0.084	0.004	-0.353	0.008	0.334	-0.305	1.000	-0.028	0.093	0.011	-0.002
TAXI_IN	0.020	0.020	0.020	0.125	0.119	-0.028	-0.037	-0.066	0.163	-0.122	-0.079	0.296	-0.012	-0.007	-0.051	-0.064	0.110	0.053	0.213	0.209	-0.028	1.000	0.067	-0.063	-0.036
TAXI_OUT	0.091	0.091	0.091	0.071	0.269	0.028	0.025	0.004	0.112	-0.139	-0.198	0.444	-0.003	0.063	0.020	0.008	0.055	0.014	0.279	0.203	0.093	0.067	1.000	0.028	0.031
WHEELS_OFF	0.049	0.049	0.049	-0.034	0.171	0.768	0.800	0.953	-0.038	-0.026	0.259	-0.100	-0.011	0.015	0.199	0.984	-0.030	0.013	0.008	-0.032	0.011	-0.063	0.028	1.000	0.789
WHEELS_ON	0.048	0.048	0.048	0.046	0.117	0.976	0.904	0.751	0.040	-0.066	0.139	-0.019	-0.014	0.012	0.141	0.774	0.052	0.039	-0.003	0.046	-0.002	-0.036	0.031	0.789	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	FL_DATE	AIRLINE	AIRLINE_DOT	AIRLINE_CODE	DOT_CODE	FL_NUMBER	ORIGIN	ORIGIN_CITY	DEST	DEST_CITY	CRS_DEP_TIME	DEP_TIME	DEP_DELAY	TAXI_OUT	WHEELS_OFF	WHEELS_ON	TAXI_IN	CRS_ARR_TIME	ARR_TIME	ARR_DELAY	CANCELLATION_CODE	CRS_ELAPSED_TIME	ELAPSED_TIME	AIR_TIME	DISTANCE	DELAY_DUE_CARRIER	DELAY_DUE_WEATHER	DELAY_DUE_NAS	DELAY_DUE_SECURITY	DELAY_DUE_LATE_AIRCRAFT
0	2019-03-01	Allegiant Air	Allegiant Air: G4	G4	20368	1668	PGD	Punta Gorda, FL	SPI	Springfield, IL	630	620.0	-10.0	9.0	629.0	731.0	7.0	810	738.0	-32.0	NaN	160.0	138.0	122.0	994.0	NaN	NaN	NaN	NaN	NaN
2	2022-04-12	PSA Airlines Inc.	PSA Airlines Inc.: OH	OH	20397	5560	EWN	New Bern/Morehead/Beaufort, NC	CLT	Charlotte, NC	625	618.0	-7.0	16.0	634.0	725.0	11.0	744	736.0	-8.0	NaN	79.0	78.0	51.0	221.0	NaN	NaN	NaN	NaN	NaN
3	2021-10-13	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	1944	ABQ	Albuquerque, NM	DEN	Denver, CO	1715	1740.0	25.0	15.0	1755.0	1844.0	7.0	1835	1851.0	16.0	NaN	80.0	71.0	49.0	349.0	10.0	0.0	0.0	0.0	6.0
4	2022-06-05	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	3081	PIT	Pittsburgh, PA	STL	St. Louis, MO	535	535.0	0.0	12.0	547.0	609.0	6.0	620	615.0	-5.0	NaN	105.0	100.0	82.0	554.0	NaN	NaN	NaN	NaN	NaN
5	2019-10-06	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	674	LAX	Los Angeles, CA	SEA	Seattle, WA	1140	1138.0	-2.0	14.0	1152.0	1405.0	11.0	1438	1416.0	-22.0	NaN	178.0	158.0	133.0	954.0	NaN	NaN	NaN	NaN	NaN
6	2020-03-17	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	443	OAK	Oakland, CA	HOU	Houston, TX	2000	2019.0	19.0	13.0	2032.0	143.0	7.0	135	150.0	15.0	NaN	215.0	211.0	191.0	1642.0	15.0	0.0	0.0	0.0	0.0
7	2020-02-06	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	1779	SFO	San Francisco, CA	SAN	San Diego, CA	1340	1338.0	-2.0	13.0	1351.0	1456.0	3.0	1520	1459.0	-21.0	NaN	100.0	81.0	65.0	447.0	NaN	NaN	NaN	NaN	NaN
8	2019-03-11	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	2135	DTW	Detroit, MI	LAS	Las Vegas, NV	714	710.0	-4.0	30.0	740.0	854.0	10.0	847	904.0	17.0	NaN	273.0	294.0	254.0	1749.0	0.0	0.0	17.0	0.0	0.0
9	2022-07-24	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	1612	DEN	Denver, CO	SLC	Salt Lake City, UT	2010	2038.0	28.0	16.0	2054.0	2159.0	5.0	2148	2204.0	16.0	NaN	98.0	86.0	65.0	391.0	16.0	0.0	0.0	0.0	0.0
10	2021-07-10	United Air Lines Inc.	United Air Lines Inc.: UA	UA	19977	1185	SLC	Salt Lake City, UT	IAH	Houston, TX	1502	1505.0	3.0	17.0	1522.0	1847.0	8.0	1900	1855.0	-5.0	NaN	178.0	170.0	145.0	1195.0	NaN	NaN	NaN	NaN	NaN

	FL_DATE	AIRLINE	AIRLINE_DOT	AIRLINE_CODE	DOT_CODE	FL_NUMBER	ORIGIN	ORIGIN_CITY	DEST	DEST_CITY	CRS_DEP_TIME	DEP_TIME	DEP_DELAY	TAXI_OUT	WHEELS_OFF	WHEELS_ON	TAXI_IN	CRS_ARR_TIME	ARR_TIME	ARR_DELAY	CANCELLATION_CODE	CRS_ELAPSED_TIME	ELAPSED_TIME	AIR_TIME	DISTANCE	DELAY_DUE_CARRIER	DELAY_DUE_WEATHER	DELAY_DUE_NAS	DELAY_DUE_SECURITY	DELAY_DUE_LATE_AIRCRAFT
99990	2019-02-19	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	377	DEN	Denver, CO	SEA	Seattle, WA	855	857.0	2.0	14.0	911.0	1043.0	4.0	1100	1047.0	-13.0	NaN	185.0	170.0	152.0	1024.0	NaN	NaN	NaN	NaN	NaN
99991	2019-02-21	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	1752	BWI	Baltimore, MD	TPA	Tampa, FL	825	825.0	0.0	30.0	855.0	1102.0	6.0	1050	1108.0	18.0	NaN	145.0	163.0	127.0	842.0	0.0	0.0	18.0	0.0	0.0
99992	2022-06-29	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	1643	ATL	Atlanta, GA	MSN	Madison, WI	950	946.0	-4.0	9.0	955.0	1036.0	8.0	1048	1044.0	-4.0	NaN	118.0	118.0	101.0	707.0	NaN	NaN	NaN	NaN	NaN
99993	2023-01-06	Spirit Air Lines	Spirit Air Lines: NK	NK	20416	1042	SJU	San Juan, PR	MCO	Orlando, FL	2130	2225.0	55.0	14.0	2239.0	17.0	39.0	2350	56.0	66.0	NaN	200.0	211.0	158.0	1189.0	0.0	0.0	11.0	0.0	55.0
99994	2023-08-05	United Air Lines Inc.	United Air Lines Inc.: UA	UA	19977	1478	LAS	Las Vegas, NV	IAH	Houston, TX	1023	1016.0	-7.0	30.0	1046.0	1517.0	3.0	1533	1520.0	-13.0	NaN	190.0	184.0	151.0	1222.0	NaN	NaN	NaN	NaN	NaN
99995	2019-02-26	Delta Air Lines Inc.	Delta Air Lines Inc.: DL	DL	19790	2229	CHS	Charleston, SC	ATL	Atlanta, GA	1244	1241.0	-3.0	13.0	1254.0	1344.0	10.0	1408	1354.0	-14.0	NaN	84.0	73.0	50.0	259.0	NaN	NaN	NaN	NaN	NaN
99996	2023-02-10	Southwest Airlines Co.	Southwest Airlines Co.: WN	WN	19393	2977	MDW	Chicago, IL	LAX	Los Angeles, CA	925	1134.0	129.0	19.0	1153.0	1322.0	11.0	1205	1333.0	88.0	NaN	280.0	239.0	209.0	1750.0	88.0	0.0	0.0	0.0	0.0
99997	2019-06-26	Endeavor Air Inc.	Endeavor Air Inc.: 9E	9E	20363	5003	ORF	Norfolk, VA	JFK	New York, NY	1712	1715.0	3.0	25.0	1740.0	1831.0	6.0	1845	1837.0	-8.0	NaN	93.0	82.0	51.0	290.0	NaN	NaN	NaN	NaN	NaN
99998	2023-06-22	Endeavor Air Inc.	Endeavor Air Inc.: 9E	9E	20363	5173	CVG	Cincinnati, OH	LGA	New York, NY	1433	1436.0	3.0	14.0	1450.0	1617.0	9.0	1640	1626.0	-14.0	NaN	127.0	110.0	87.0	585.0	NaN	NaN	NaN	NaN	NaN
99999	2022-01-07	Endeavor Air Inc.	Endeavor Air Inc.: 9E	9E	20363	5227	ATL	Atlanta, GA	SHV	Shreveport, LA	1345	1420.0	35.0	10.0	1430.0	1456.0	4.0	1438	1500.0	22.0	NaN	113.0	100.0	86.0	551.0	0.0	0.0	0.0	0.0	22.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length